EDA Profile

Dataset statistics

Number of variables	12
Number of observations	2773
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	281.6 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`avg_ticket` is highly overall correlated with `unique_basket_size`	High correlation
`basket_size` is highly overall correlated with `revenue` and 1 other fields	High correlation
`distinct_stock_code` is highly overall correlated with `revenue` and 3 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`revenue` is highly overall correlated with `basket_size` and 3 other fields	High correlation
`total_products` is highly overall correlated with `basket_size` and 3 other fields	High correlation
`total_purchases` is highly overall correlated with `distinct_stock_code` and 2 other fields	High correlation
`unique_basket_size` is highly overall correlated with `avg_ticket` and 1 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 27.67827335)	Skewed
`frequency` is highly skewed (γ1 = 46.07740946)	Skewed
`returned` is highly skewed (γ1 = 21.6260127)	Skewed
`customer_id` has unique values	Unique
`recency` has 33 (1.2%) zeros	Zeros
`returned` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2024-05-24 23:40:32.738762
Analysis finished	2024-05-24 23:41:16.846382
Duration	44.11 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2773
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.281

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.6
Q1	13815
median	15241
Q3	16780
95-th percentile	17950.4
Maximum	18287
Range	5940
Interquartile range (IQR)	2965

Descriptive statistics

Standard deviation	1715.1526
Coefficient of variation (CV)	0.11220942
Kurtosis	-1.2070293
Mean	15285.281
Median Absolute Deviation (MAD)	1484
Skewness	0.016612507
Sum	42386085
Variance	2941748.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14482	1	< 0.1%
17058	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
17930	1	< 0.1%
Other values (2763)	2763	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2759
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2844.942

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.548
Q1	628
median	1169.94
Q3	2423.32
95-th percentile	7490.982
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.32

Descriptive statistics

Standard deviation	10466.686
Coefficient of variation (CV)	3.6790506
Kurtosis	372.80205
Mean	2844.942
Median Absolute Deviation (MAD)	689.02
Skewness	17.097705
Sum	7889024.2
Variance	1.0955151 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
745.06	2	0.1%
889.93	2	0.1%
734.94	2	0.1%
331	2	0.1%
1314.45	2	0.1%
379.65	2	0.1%
1353.74	2	0.1%
598.2	2	0.1%
1078.96	2	0.1%
Other values (2749)	2753	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65019.62	1	< 0.1%

recency
Real number (ℝ)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.648395

Minimum	0
Maximum	372
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.422907
Coefficient of variation (CV)	1.2078525
Kurtosis	3.4305436
Mean	56.648395
Median Absolute Deviation (MAD)	23
Skewness	1.8980349
Sum	157086
Variance	4681.6942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
2	85	3.1%
3	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2026	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION

Distinct	1155
Distinct (%)	41.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.756379

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.222222
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.777778

Descriptive statistics

Standard deviation	66.483798
Coefficient of variation (CV)	0.84417032
Kurtosis	3.6897278
Mean	78.756379
Median Absolute Deviation (MAD)	30
Skewness	1.8311845
Sum	218391.44
Variance	4420.0954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
49	16	0.6%
31	16	0.6%
91	16	0.6%
21	15	0.5%
35	15	0.5%
42	15	0.5%
28	14	0.5%
Other values (1145)	2610	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

total_products
Real number (ℝ)

HIGH CORRELATION

Distinct	1631
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1669.2236

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330
median	699
Q3	1478
95-th percentile	4614
Maximum	196844
Range	196842
Interquartile range (IQR)	1148

Descriptive statistics

Standard deviation	5885.8021
Coefficient of variation (CV)	3.5260717
Kurtosis	486.75708
Mean	1669.2236
Median Absolute Deviation (MAD)	449
Skewness	18.198824
Sum	4628757
Variance	34642666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	8	0.3%
246	8	0.3%
516	7	0.3%
1200	7	0.3%
200	7	0.3%
272	7	0.3%
219	7	0.3%
260	7	0.3%
300	7	0.3%
Other values (1621)	2697	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%
50255	1	< 0.1%

distinct_stock_code
Real number (ℝ)

HIGH CORRELATION

Distinct	341
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.315543

Minimum	1
Maximum	1785
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	29
median	57
Q3	105
95-th percentile	239.4
Maximum	1785
Range	1784
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	98.71334
Coefficient of variation (CV)	1.184813
Kurtosis	80.51239
Mean	83.315543
Median Absolute Deviation (MAD)	33
Skewness	6.3469448
Sum	231034
Variance	9744.3236
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	38	1.4%
24	37	1.3%
33	36	1.3%
26	36	1.3%
25	34	1.2%
18	33	1.2%
28	33	1.2%
30	32	1.2%
27	30	1.1%
23	29	1.0%
Other values (331)	2435	87.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	0.7%
2	13	0.5%
3	17	0.6%
4	18	0.6%
5	23	0.8%
6	19	0.7%
7	21	0.8%
8	24	0.9%
9	24	0.9%
10	19	0.7%

Value	Count	Frequency (%)
1785	1	< 0.1%
1765	1	< 0.1%
1321	1	< 0.1%
1118	1	< 0.1%
883	1	< 0.1%
817	1	< 0.1%
717	1	< 0.1%
713	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

total_purchases
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0544537

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.0729125
Coefficient of variation (CV)	1.4985518
Kurtosis	183.89793
Mean	6.0544537
Median Absolute Deviation (MAD)	2
Skewness	10.623447
Sum	16789
Variance	82.317741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	780	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	780	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1931
Distinct (%)	69.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	230.94908

Minimum	1
Maximum	6009.3333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.33333
median	172
Q3	278.09524
95-th percentile	583.6
Maximum	6009.3333
Range	6008.3333
Interquartile range (IQR)	174.7619

Descriptive statistics

Standard deviation	261.5335
Coefficient of variation (CV)	1.1324293
Kurtosis	115.89887
Mean	230.94908
Median Absolute Deviation (MAD)	81
Skewness	7.7349287
Sum	640421.79
Variance	68399.773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
197	7	0.3%
73	7	0.3%
82	7	0.3%
136	7	0.3%
105	7	0.3%
208	7	0.3%
Other values (1921)	2695	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%
1866.933333	1	< 0.1%

unique_basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1003
Distinct (%)	36.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.129792

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.5
Q1	10.133333
median	17.307692
Q3	28.111111
95-th percentile	56.648485
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.977778

Descriptive statistics

Standard deviation	18.867714
Coefficient of variation (CV)	0.85259337
Kurtosis	24.175983
Mean	22.129792
Median Absolute Deviation (MAD)	8.3076923
Skewness	3.1580319
Sum	61365.914
Variance	355.99064
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	44	1.6%
14	31	1.1%
11	29	1.0%
9	26	0.9%
1	26	0.9%
17.5	25	0.9%
10.5	25	0.9%
7.5	25	0.9%
9.5	24	0.9%
18	24	0.9%
Other values (993)	2494	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26	0.9%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	7	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	21	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
203.5	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%
110.3333333	1	< 0.1%
109.6666667	2	0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2771
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.106572

Minimum	2.1505882
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.8524538
Q1	12.41668
median	17.943444
Q3	25.025556
95-th percentile	87.757474
Maximum	4453.43
Range	4451.2794
Interquartile range (IQR)	12.608876

Descriptive statistics

Standard deviation	107.63141
Coefficient of variation (CV)	3.3523171
Kurtosis	1054.6276
Mean	32.106572
Median Absolute Deviation (MAD)	6.3346556
Skewness	27.678273
Sum	89031.523
Variance	11584.52
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
25.6761194	1	< 0.1%
44.95564103	1	< 0.1%
32.59775	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
26.08797101	1	< 0.1%
Other values (2761)	2761	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%
602.4531323	1	< 0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1225
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.049706611

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0087463557
Q1	0.015789474
median	0.024390244
Q3	0.041666667
95-th percentile	0.11538462
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.025877193

Descriptive statistics

Standard deviation	0.33765504
Coefficient of variation (CV)	6.7929604
Kurtosis	2295.7098
Mean	0.049706611
Median Absolute Deviation (MAD)	0.010691614
Skewness	46.077409
Sum	137.83643
Variance	0.11401092
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	17	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.07692307692	13	0.5%
0.02127659574	13	0.5%
0.02564102564	13	0.5%
Other values (1215)	2626	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

returned
Real number (ℝ)

SKEWED ZEROS

Distinct	204
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.973675

Minimum	0
Maximum	9014
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	96.8
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	290.71429
Coefficient of variation (CV)	8.3123747
Kurtosis	571.74568
Mean	34.973675
Median Absolute Deviation (MAD)	0
Skewness	21.626013
Sum	96982
Variance	84514.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (194)	652	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

Auto

Heatmap
Table

	avg_recency_days	avg_ticket	basket_size	customer_id	distinct_stock_code	frequency	recency	returned	revenue	total_products	total_purchases	unique_basket_size
avg_recency_days	1.000	-0.080	-0.043	-0.012	-0.221	-0.952	0.225	-0.215	-0.367	-0.344	-0.476	0.062
avg_ticket	-0.080	1.000	0.198	-0.141	-0.465	0.082	0.035	0.188	0.273	0.195	0.091	-0.626
basket_size	-0.043	0.198	1.000	-0.121	0.400	0.026	-0.103	0.214	0.602	0.759	0.126	0.433
customer_id	-0.012	-0.141	-0.121	1.000	0.009	0.014	0.014	-0.058	-0.086	-0.079	0.013	0.006
distinct_stock_code	-0.221	-0.465	0.400	0.009	1.000	0.141	-0.336	0.282	0.635	0.633	0.544	0.798
frequency	-0.952	0.082	0.026	0.014	0.141	1.000	-0.127	0.176	0.259	0.240	0.322	-0.071
recency	0.225	0.035	-0.103	0.014	-0.336	-0.127	1.000	-0.186	-0.373	-0.365	-0.448	-0.105
returned	-0.215	0.188	0.214	-0.058	0.282	0.176	-0.186	1.000	0.461	0.426	0.427	0.027
revenue	-0.367	0.273	0.602	-0.086	0.635	0.259	-0.373	0.461	1.000	0.922	0.763	0.282
total_products	-0.344	0.195	0.759	-0.079	0.633	0.240	-0.365	0.426	0.922	1.000	0.704	0.312
total_purchases	-0.476	0.091	0.126	0.013	0.544	0.322	-0.448	0.427	0.763	0.704	1.000	0.016
unique_basket_size	0.062	-0.626	0.433	0.006	0.798	-0.071	-0.105	0.027	0.282	0.312	0.016	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	revenue	recency	avg_recency_days	total_products	distinct_stock_code	total_purchases	basket_size	unique_basket_size	avg_ticket	frequency	returned
0	17850	5391.21	372.0	1.000000	1733.0	21.0	34.0	50.970588	8.735294	18.152222	17.000000	40.0
1	13047	3232.59	56.0	52.833333	1390.0	105.0	9.0	154.444444	19.000000	18.904035	0.028302	35.0
2	12583	6705.38	2.0	26.500000	5028.0	114.0	15.0	335.200000	15.466667	28.902500	0.040323	50.0
3	13748	948.25	95.0	92.666667	439.0	24.0	5.0	87.800000	5.600000	33.866071	0.017921	0.0
4	15100	876.00	333.0	20.000000	80.0	1.0	3.0	26.666667	1.000000	292.000000	0.073171	22.0
5	15291	4623.30	25.0	26.769231	2102.0	61.0	14.0	150.142857	7.285714	45.326471	0.040115	29.0
6	14688	5630.87	7.0	19.263158	3621.0	148.0	21.0	172.428571	15.571429	17.219786	0.057221	399.0
7	17809	5411.91	16.0	39.666667	2057.0	46.0	12.0	171.416667	5.083333	88.719836	0.033520	41.0
8	15311	60767.90	0.0	4.191011	38194.0	567.0	91.0	419.714286	26.142857	25.543464	0.243316	474.0
9	16098	2005.63	87.0	47.666667	613.0	34.0	7.0	87.571429	9.571429	29.934776	0.024390	0.0

	customer_id	revenue	recency	avg_recency_days	total_products	distinct_stock_code	total_purchases	basket_size	unique_basket_size	avg_ticket	frequency	returned
5610	17290	525.24	3.0	13.0	404.0	92.0	2.0	202.000000	51.0	5.149412	0.142857	0.0
5619	14785	77.40	10.0	5.0	84.0	2.0	2.0	42.000000	1.5	25.800000	0.333333	0.0
5620	17254	272.44	4.0	11.0	252.0	100.0	2.0	126.000000	56.0	2.432500	0.166667	0.0
5636	17232	421.52	2.0	12.0	203.0	30.0	2.0	101.500000	18.0	11.708889	0.153846	0.0
5637	17468	137.00	10.0	4.0	116.0	5.0	2.0	58.000000	2.5	27.400000	0.400000	0.0
5648	13596	697.04	5.0	7.0	406.0	133.0	2.0	203.000000	83.0	4.199036	0.250000	0.0
5654	14893	1237.85	9.0	2.0	799.0	72.0	2.0	399.500000	36.5	16.956849	0.666667	0.0
5679	14126	706.13	7.0	3.0	508.0	14.0	3.0	169.333333	5.0	47.075333	0.750000	50.0
5685	13521	1092.39	1.0	4.5	733.0	312.0	3.0	244.333333	145.0	2.511241	0.300000	0.0
5695	15060	301.84	8.0	1.0	262.0	80.0	4.0	65.500000	30.0	2.515333	2.000000	0.0

Overview

Variables

Interactions

Correlations

Missing values

Sample